Order function

To apply function:

§          Order                                        MDX Order function

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

for axis function you need to

§          … right-click inside row or column area

§          … select Axis functions menu

then select

§          … any Order function from submenu

 

 

In our case let us try to define:

 

order table by measure Store Cost in descending order with breaking hierarchies

 

Dialog will appear:

 

 

§          define  measure if selected one is not suitable for you

o         we will replace Unit sale as we said with Store Cost

Ø       to select another measure, just click button Select

Ø       select from dialog  measure Store Cost

Ø       select Ok

§          define members to create tuple if appropriate (not in our case)

o         for example to add Food select button Add

Ø       find  member Food

Ø       select Ok

§          select appropriate option

o         BDESC

o         DESC

o         BASC

o         ASC

§          select OK

 

When we set all parameters as we agreed, dialog will look like this:

 

 

After confirmation result is: